Tabela BillType

Definicja tabeli BillType

Name

BillType

Code

BillType

Comment

 


Lista kolumn tabeli BillType

Name

Code

BillTypeID

BillTypeID

Active

Active

Code

Code

FullName

FullName

ShortName

ShortName

StartDT

StartDT

StopDT

StopDT


Kolumna BillTypeID tabeli BillType

Definicja kolumny BillTypeID tabeli BillType

Name

BillTypeID

Code

BillTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli BillType

Definicja kolumny Active tabeli BillType

Name

Active

Code

Active

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Code tabeli BillType

Definicja kolumny Code tabeli BillType

Name

Code

Code

Code

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna FullName tabeli BillType

Definicja kolumny FullName tabeli BillType

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ShortName tabeli BillType

Definicja kolumny ShortName tabeli BillType

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(90)

Mandatory

No

Comment

 


Kolumna StartDT tabeli BillType

Definicja kolumny StartDT tabeli BillType

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Data poczatku obowiazywania danego typu rachunku


Kolumna StopDT tabeli BillType

Definicja kolumny StopDT tabeli BillType

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Data konca obowiazywania danego typu rachunku


Lista kluczy tabeli BillType

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli BillType

Definicja klucza Identifier_1 tabeli BillType

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment